package wu.mapper;

import org.apache.ibatis.annotations.Update;

import java.util.Map;

public interface CreateTableMapper {
    @Update("CREATE TABLE ${tableName}\n" +
            "        (\n" +
            "            niu_id          INT PRIMARY KEY,\n" +
            "            niu_Ranking     VARCHAR(50),\n" +
            "            niu_Contestants VARCHAR(50),\n" +
            "            niu_School      VARCHAR(100),\n" +
            "            niu_AC          VARCHAR(50),\n" +
            "            niu_total_score VARCHAR(50),\n" +
            "            niu_time        VARCHAR(50),\n" +
            "            A_score DOUBLE,\n" +
            "            B_score DOUBLE,\n" +
            "            C_score DOUBLE,\n" +
            "            D_score DOUBLE,\n" +
            "            E_score DOUBLE,\n" +
            "            F_score DOUBLE,\n" +
            "            G_score DOUBLE\n" +
            "        )")
    public void createtable222 (Map<String, String> params);
}
